-
General Inquiries +234(0)8023087440
•
-
Support enquiry@globaltechworld.net
Complete Course Details
Adv Microsoft Excel AND Macro
Actual Price:₦ 850,000.00
Tuition Fee(Pay Just 50%) : ₦ 425,000.00
/ USD: $ 559.21
Advance Microsoft Excel 2016 - 2021
Using a Pivot Table Filtering and Sorting Data Grouping Data INPUT TABLES One
- Input Data Tables Two
- Input Data Tables CHARTS Combin ed Line and Column Chart
- Adding a Secondary Axis
- Changing the Chart Type For a Data Series
- Adding a Data Series to a Chart
- Removing a Data Series from a Chart
- Modifying the Chart Title,
- Legend & Data Labels Chart Axis Scales
- Inserting Images Into Chart Columns
- Formatting the Chart Area HYPERLINKS
- Inserting a Hyperlink Editing a Hyperlink
- Removing a Hyperlink
- IMPORTING TEXT FILES Importing a Delimited Text File
- LINKING AND EMBEDDING
- Linking Data within a Worksheet
- Linking Cells between Worksheets within a Workbook
- Linking Data between Workbooks
- Linking Data from Excel to a Word Document
- Linking an Excel Chart to a Word Document
- Updating, Locking and Breaking
- Links SORTING AND FILTERING DATA
- Sorting Data by Multiple Columns Custom Sorts
- SORTING AND FILTERING cont..
- Customized List AutoFilter Top 10 AutoFilter Advanced Filter Criteria Sub - Totalling Removing Subtotals Expanding and Collapsing Outline Detail TRACKING AND REVIEWING CHANGES Enabling or Disabling 'Track Changes' Sharing, Comparing and Merging Worksheets SCENARIOS Scenario Manager and Summary Reports
Advance Microsoft Excel 2010 - 2016
Using a Pivot Table Filtering and Sorting Data Grouping Data INPUT TABLES One
- Input Data Tables Two
- Input Data Tables CHARTS Combin ed Line and Column Chart
- Adding a Secondary Axis
- Changing the Chart Type For a Data Series
- Adding a Data Series to a Chart
- Removing a Data Series from a Chart
- Modifying the Chart Title,
- Legend & Data Labels Chart Axis Scales
- Inserting Images Into Chart Columns
- Formatting the Chart Area HYPERLINKS
- Inserting a Hyperlink Editing a Hyperlink
- Removing a Hyperlink
- IMPORTING TEXT FILES Importing a Delimited Text File
- LINKING AND EMBEDDING
- Linking Data within a Worksheet
- Linking Cells between Worksheets within a Workbook
- Linking Data between Workbooks
- Linking Data from Excel to a Word Document
- Linking an Excel Chart to a Word Document
- Updating, Locking and Breaking
- Links SORTING AND FILTERING DATA
- Sorting Data by Multiple Columns Custom Sorts
- SORTING AND FILTERING cont..
- Customized List AutoFilter Top 10 AutoFilter Advanced Filter Criteria Sub - Totalling Removing Subtotals Expanding and Collapsing Outline Detail TRACKING AND REVIEWING CHANGES Enabling or Disabling 'Track Changes' Sharing, Comparing and Merging Worksheets SCENARIOS Scenario Manager and Summary Reports
Actual Fee: N425,000
WEEKDAYS Duration: 8weeks Practical Training
WEEKEND Duration: 6Saturdays Practical Training
NB: That Weekend Corporate Training exlusively designed professionals which attract payment of
N10,000
* 3Days Lectures per Week ::
* 9Hours Weekly
GLOBALTECHS is a Dynamic ICT Training and Consultancy firm in Nigeria Providing Technology Solutions for both Home & Business. GLOBALTECHS ICT Career Solution for Individual, Corporate Organization, Professionals and Graduate|Undergrate who are ready to take their Skill to the next level